{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Tjek","Gl_Satser","Satser","kommuner_afd","Ark3","Ark1"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":14,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tjek","index":0,"n_rows":85,"n_cols":27,"rows_kept":85,"cut":false,"hidden":false,"merged":[[1,8,1,10]]}
[]
[null,null,"Satser pr. : 01-06-2013 til 01-03-2020",null,null,null,null,null,"Slet indtastninger: Ctrl+q",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-03-01"]
[null,{"$f":"VLOOKUP(C11,$C$61:$E$64,2,FALSE)","v":{"$error":"#N/A"}},"LØNTJEK",null,null,null,null,null,"OVERENSKOMST: KA Pleje",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-05-01"]
[null,{"$f":"C17","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-06-01"]
[null,null,"Måned, lønseddel",null,null,null,null,null,"Grundløn:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-07-01"]
[null,null,null,null,null,null,null,null,"grundløn",null,{"$f":"IFERROR(VLOOKUP(stilling,grundløn,VLOOKUP(C7,kolonne_nr,2,TRUE)+3,FALSE)/fuldtidsnorm*$C$22,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-08-01"]
[null,null,{"$f":"IF(C7<>\"\",DATE(YEAR(C7),MONTH(C7)-1,DAY(C7)),\"\")","v":""},null,null,null,null,null,"gruppetillæg",null,{"$f":"IFERROR(VLOOKUP(område,område_tillæg,VLOOKUP(C7,kolonne_nr,2,TRUE)+2,FALSE)/fuldtidsnorm*$C$22,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-10-01"]
[null,null,"Stilling:",null,null,null,null,null,"Tillæg:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-11-01"]
[null,null,null,null,null,null,null,null,"personligt tillæg",null,{"$f":"J11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2013-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-01-01"]
[null,null,null,null,null,null,null,null,"anciennitetstillæg (antal år)",null,{"$f":"IFERROR(IF(modregning=\"\",L13,IF(K11>=L13,0,L13-J11)),0)","v":0},{"$f":"(VLOOKUP(J13,erfa_tillæg,VLOOKUP(C7,kolonne_nr,2,TRUE)+2,TRUE)/fuldtidsnorm*$C$22)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-03-01"]
[null,null,null,null,null,null,null,null,"funktionstillæg, lokalt aftalt",null,{"$f":"J15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-04-01"]
[null,null,"Område/løngruppe:",null,null,null,null,null,"kvalifikationstill., lokalt aftalt",null,{"$f":"J16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-06-01"]
[null,null,null,null,null,null,null,null,"fast månedsløn/personlig løn",null,{"$f":"SUM(K7:K16)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-07-01"]
[null,null,null,null,null,null,null,null,"timeløn",null,{"$f":"IFERROR((K18/timetal*fuldtidsnorm)*12/1924,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-09-01"]
[null,null,"Timetal (timer/uge jf. ansættelsesbrev):",null,null,null,null,null,"Særydelser:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-10-01"]
[null,null,null,null,null,null,null,null,"merarbejde/udbetalt afsp.",null,{"$f":"K19*J22","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-11-01"]
[null,null,{"$f":"\"(svarende til \"&ROUND(timetal*52/12,2)&\" løntimer/måned)\"","v":"(svarende til 0 løntimer/måned)"},null,null,null,null,null,"overarbejde",null,{"$f":"K19*(1+50%)*(CEILING(J23*2,1)/2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2014-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-01-01"]
[null,null,null,null,null,null,null,null,"timer; 18-06 ",null,{"$f":"IFERROR((CEILING(J25*2,1)/2)*VLOOKUP(4,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-02-01"]
[null,null,null,null,null,null,null,null,"timer; lørdag 14-24",null,{"$f":"IFERROR((CEILING(J26*2,1)/2)*VLOOKUP(5,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-03-01"]
[null,null,null,null,null,null,null,null,"timer; søn- og helligdag ",null,{"$f":"IFERROR((K19*VLOOKUP(6,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE))*(CEILING(J27*2,1)/2),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-05-01"]
[null,null,null,null,null,null,null,null,"delt tjeneste",null,{"$f":"IFERROR((CEILING(J29,1))*VLOOKUP(1,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-06-01"]
[null,null,null,null,null,null,null,null,"omlagt tjeneste ",null,{"$f":"IFERROR((CEILING(J30*2,1)/2)*VLOOKUP(2,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-07-01"]
[null,null,null,null,null,null,null,null,"inddraget fridøgn",null,{"$f":"IFERROR((CEILING(J31,1))*VLOOKUP(3,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-08-01"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J32*omlagt","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-09-01"]
[null,null,null,null,null,null,null,null,"rådighedsvagt (bolig)",null,{"$f":"IFERROR(J33*VLOOKUP(7,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-10-01"]
[null,null,null,null,null,null,null,null,"standby vagt",null,{"$f":"IFERROR(J34*VLOOKUP(8,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-11-01"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"J35*rådighed_vagtv*K19","v":{"$error":"#NAME?"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2015-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-01-01"]
[null,null,null,null,null,null,null,null,"Beklædningsgodtg. (vask)",null,{"$f":"IF(G37<>\"\",timetal*52/12*VLOOKUP(9,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-02-01"]
[null,null,null,null,null,null,null,null,"Beklædningsgodtg. (vask og tøj)",null,{"$f":"IF(G38<>\"\",timetal*52/12*VLOOKUP(10,særydelser,VLOOKUP(C8,kolonne_nr,2,TRUE)+2,FALSE),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-03-01"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(VLOOKUP(stilling,løndele,25,FALSE)*J39*timetal,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-08-01"]
[null,null,null,null,null,null,null,null,"Pensionsgivende løn",null,{"$f":"SUM(K18,K22:K23,K25:K27,K29:K30,K33:K34,K37:K38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-10-01"]
[null,null,null,null,null,null,null,null,false,{"$f":"IF(I46=TRUE,12.3%,\"\")","v":""},{"$f":"IFERROR(J46*K44,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-11-01"]
[null,null,null,null,null,null,null,null,null,{"$f":"IFERROR(J46/3,\"\")","v":""},{"$f":"IFERROR(J47*$K$44,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2016-12-01"]
[null,null,null,null,null,null,null,null,"pensionsbidrag, arbejdsgiver",{"$f":"IFERROR(J46/3*2,\"\")","v":""},{"$f":"IFERROR(J48*$K$44,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-07-01"]
[null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-08-01"]
[null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-09-01"]
[null,null,2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-10-01"]
[null,null,3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-11-01"]
[null,null,4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2017-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-01-01"]
[null,null,"Ikke-uddannede, husassist., servicemedarb.",1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-02-01"]
[null,null,"Hjemmehjælpere",2,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-03-01"]
[null,null,"Social- og sundhedshj., sygehj. m.fl.",3,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-04-01"]
[null,null,"Social- og sundhedsass., plejehj.ass., plejere",4,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2018-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-02-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-03-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-04-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-05-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-06-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-07-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-08-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-09-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-10-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-11-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2019-12-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-01-01"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2020-02-01"]

{"sheet":"Gl_Satser","index":1,"n_rows":33,"n_cols":28,"rows_kept":33,"cut":false,"hidden":true,"merged":[]}
[null,null,"§5, 1","§5a, 2","§5a, 2","§5b","§7, 1","§7, 1","§9",null,"§ 20, 2","§ 23, 3","§ 25, 1","§ 25, 2","§ 25, 3","§ 26, 2",null,"§ 27, 2",null,null,null,null,null,"§ 14","§ 14"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28]
[null,"2013-03-01","Grundløn","Grundløn","Grundløn","servicetill.",null,null,"Særlig opsp.","delt tjeneste","omlagte timer","inddraget",null,"lø",null,"Rådighed",null,"stand-by",null,null,null,null,null,"Beklædningsgodtgørelse"]
[null,null,null,"gr. 1 og 2","gr. 3 og 4",null,null,null,null,null,null,"fridøgn","18-06","14-24","sø/hell.","bopæl",null,null,null,null,null,null,null,"vask","vask og tøj"]
[1,"Ikke-uddannede, husass., servicemedarb",20098.28,512,1025,null,null,null,null,41.41,43.48,358.21,35.549999999999997,35.200000000000003,0.5,33.46,null,18.829999999999998,null,null,null,null,null,0.9,2.0699999999999998]
[2,"Hjemmehjælpere",21162.25]
[3,"SSHJ, sygehj. m.fl.",21666.18]
[4,"SSA, plejehj.ass., plejere",22562.85]
[]
["§ 5, 2","Områdetillæg"]
[0,0,null,"fuld tid, månedsnorm"]
[1,512,null,{"$f":"37","v":37}]
[2,512]
[3,1025]
[4,1025,null,null,null,null,"Grundløn"]
[null,null,null,null,null,null,"2012-06-01","2013-06-01","2013-06-01",41.41,43.48,358.21,35.909999999999997,35.200000000000003,0.5,33.799999999999997,null,19.010000000000002,null,null,null,null,null,0.9,2.0699999999999998]
["§ 7, 1-2","erfaringstillæg",null,null,null,"Ikke-uddannede, husass., servicemedarb",19899.29,20098.28,"2012-06-01",41.41,43.48,358.21,35.549999999999997,35.200000000000003,0.5,33.46,null,18.829999999999998,null,null,null,null,null,0.9,2.0699999999999998]
[0,0,null,null,null,"Hjemmehjælpere",20952.72,21162.25]
[1,0,null,null,null,"SSHJ, sygehj. m.fl.",21451.66,21666.18]
[2,0,null,null,null,"SSA, plejehj.ass., plejere",22339.45,22562.85]
[3,1060]
[4,1060,null,null,null,null,{"$f":"C8+E5","v":23587.85}]
[5,1060,null,null,null,21785.14,{"$f":"160.33/G22*F23","v":148.07672154096284}]
[6,1660]
[7,1660]
[8,1660]
[]
[]
["§ 15, 2+5+7","pension","arbejdsgiverbidrag",null,null,null,null,{"$f":"37/23364.45*21785.14","v":34.499000832461284}]
[null,"egetbidrag","inkl. sundhedsbidrag"]
[{"$f":"A33/3","v":4.1000000000000002E-2},{"$f":"A31/3","v":1.3666666666666667E-2},{"$f":"A31/3*2","v":2.7333333333333334E-2}]
[{"$f":"A33/3*2","v":8.2000000000000003E-2},2.7333333333333334E-2,5.4666666666666669E-2]
[0.123,{"$f":"A33/3","v":4.1000000000000002E-2},{"$f":"A33/3*2","v":8.2000000000000003E-2}]

{"sheet":"Satser","index":2,"n_rows":38,"n_cols":14,"rows_kept":38,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,1,2,3,4,5,6,7]
["fuld tid, månedsnorm",null,null,null,null,null,"2012-06-01","2013-06-01","2014-06-01","2015-06-01","2016-06-01","2017-06-01","2018-06-01","2019-06-01"]
[37]
[null,null,null,null,null,null,null,null,1.4999999999999999E-2,1.6E-2,1.7000000000000001E-2]
["Kolonnenummer:",null,null,"§ 19,3","Delt tjeneste",1,41.41,41.41,{"$f":"H5*(1+I$4)","v":42.03114999999999},{"$f":"I5*(1+J$4)","v":42.703648399999992},43.429610422799989,44.12,44.83,45.55]
["2012-06-01",0,null,"§ 20,2","omlagte timer",2,43.48,43.48,{"$f":"H6*(1+I$4)","v":44.13219999999999},44.83831519999999,45.600566558399983,46.33,47.07,47.82]
["2013-06-01",1,null,"§ 23,3","inddraget fridøgn",3,358.21,358.21,{"$f":"H7*(1+I$4)","v":363.58314999999993},369.40048039999994,375.6802885667999,381.69,387.8,394]
["2014-06-01",2,null,"§ 25, 1","18-07",4,35.549999999999997,35.909999999999997,{"$f":"H8*(1+I$4)","v":36.448649999999994},37.031828399999995,37.661369482799991,38.26,38.869999999999997,39.49]
["2015-06-01",3,null,"§ 25, 2","lø/14-24",5,35.200000000000003,35.200000000000003,{"$f":"H9*(1+I$4)","v":35.728000000000002},36.299648000000005,36.916742016000001,37.51,38.11,38.72]
["2016-06-01",4,null,"§ 25, 3","sø/hell.",6,0.5,0.5,0.5,0.5,0.5,0.5,0.5,0.5]
["2017-06-01",5,null,"§ 26,2","Rådighed, fra bopæl",7,33.46,33.799999999999997,{"$f":"H11*(1+I$4)","v":34.306999999999995},34.855911999999996,35.448462503999991,36.020000000000003,36.6,37.19]
["2018-06-01",6,null,"§ 27,2","Standby-vagt",8,18.829999999999998,19.010000000000002,{"$f":"H12*(1+I$4)","v":19.29515},19.6038724,19.937138230799999,20.260000000000002,20.58,20.91]
["2019-06-01",7,null,"§14","Bekl.godtg./vask",9,0.9,0.9,0.9,0.9,0.9,0.9,0.9,0.9]
[null,null,null,"§25","Bekl.godtg./vask og tøj",10,2.0699999999999998,2.0699999999999998,2.0699999999999998,2.0699999999999998,2.0699999999999998,2.0699999999999998,2.0699999999999998,2.0699999999999998]
[]
[null,null,null,"§5, 1","Grundløn",null,null,null,320.66000000000003,400.83,505.04]
[null,null,null,null,"Ikke-uddannede, husassist., servicemedarb.",null,null,20098.28,{"$f":"H17+I$16","v":20418.939999999999},{"$f":"I17+J$16","v":20819.77},21324.81,21725.64,22126.47,22527.3]
[null,null,null,null,"Hjemmehjælpere",null,null,21162.25,{"$f":"H18+I$16","v":21482.91},21883.74,22388.780000000002,22789.61,23190.44,23591.27]
[null,null,null,null,"Social- og sundhedshj., sygehj. m.fl.",null,null,21666.18,21986.84,22387.670000000002,22892.710000000003,23293.54,23694.37,24095.200000000001]
[null,null,null,null,"Social- og sundhedsass., plejehj.ass., plejere",null,null,22562.85,22883.51,23284.34,23789.38,24430.71,25031.95,25673.279999999999]
[]
[null,null,null,"§ 5, 2","Områdetillæg"]
[null,null,null,null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,1,null,512,512,512,512,512,512,512]
[null,null,null,null,null,2,null,512,512,512,512,512,512,512]
[null,null,null,null,null,3,null,1025,1025,1025,1025,1025,1025,1025]
[null,null,null,null,null,4,null,1025,1025,1025,1025,1025,1025,1025]
[]
[null,null,null,"§ 7, 1-2","erfaringstillæg, "]
[null,null,null,null,null,0,null,0,0,0,0,0,0,0]
[null,null,null,null,null,1,null,0,0,0,0,0,0,0]
[null,null,null,null,null,2,null,0,0,0,0,0,0,0]
[null,null,null,null,null,3,null,1060,1060,1060,1060,1060,1060,1060]
[null,null,null,null,null,4,null,1060,1060,1060,1060,1060,1060,1060]
[null,null,null,null,null,5,null,1060,1060,1060,1060,1060,1060,1060]
[null,null,null,null,null,6,null,1660,1660,1660,1660,1660,1660,1660]
[null,null,null,null,null,7,null,1660,1660,1660,1660,1660,1660,1660]
[null,null,null,null,null,8,null,1660,1660,1660,1660,1660,1660,1660]

{"sheet":"kommuner_afd","index":3,"n_rows":99,"n_cols":9,"rows_kept":99,"cut":false,"hidden":true,"merged":[]}
["k.nr.","k.navn","løngruppe","afd","Kommune","Region"]
[165,"Albertslund",4,"FOA/PMF afd. 4",165,1,null,"Ikke-uddannede, husass., servicemedarb",1]
[201,"Allerød",3,"FOA Nordsjælland",201,1,null,"Hjemmehjælpere",2]
[420,"Assens",0,"FOA/PMF Fyns amt",420,3,null,"SSHJ, sygehj. m.fl.",3]
[151,"Ballerup",4,"FOA/PMF afd. 1",151,1,null,"SSA, plejehj.ass., plejere",4]
[530,"Billund",0,"FOA Varde",530,3]
[400,"Bornholm",0,"FOA Bornholm",400,1]
[153,"Brøndby",4,"FOA/PMF Københavns amt Syd",153,1]
[810,"Brønderslev-Dronninglund",0,"FOA/PMF Vendsyssel",810,5]
[155,"Dragør",4,"FOA/PMF Københavns amt Syd",155,1]
[240,"Egedal",4,"FOA Frederiskssund",240,1]
[561,"Esbjerg",1,"FOA Esbjerg",561,3]
[563,"Fanø",0,"FOA Esbjerg",563,3]
[710,"Favrskov",0,"FOA Randers",710,4]
[320,"Faxe",0,"FOA Sydsjælland",320,2]
[210,"Fredensborg",3,"FOA Nordsjælland",210,1]
[607,"Fredericia",0,"FOA Lillebælt",607,3]
[147,"Frederiksberg",4,"LFS",147,1]
[813,"Frederikshavn",1,"FOA/PMF Vendsyssel",813,5]
[250,"Frederikssund",3,"FOA Frederiskssund",250,1]
[190,"Furesø",4,"FOA/PMF afd. 1",190,1]
[430,"Faaborg-Midtfyn",1,"FOA/PMF Fyns amt",430,3]
[157,"Gentofte",4,"FOA/PMF afd. 1",157,1]
[159,"Gladsaxe",4,"FOA/PMF afd. 1",159,1]
[161,"Glostrup",4,"FOA/PMF Københavns amt Syd",161,1]
[253,"Greve",4,"FOA Roskilde",253,2]
[270,"Gribskov",3,"FOA Nordsjælland",270,1]
[376,"Guldborgsund",0,"FOA Nykøbing F.",376,2]
[510,"Haderslev",0,"FOA Sønderjylland",510,3]
[260,"Halsnæs",3,"FOA Frederiskssund",260,1]
[766,"Hedensted",0,"FOA Horsens",766,4]
[217,"Helsingør",3,"FOA Nordsjælland",217,1]
[163,"Herlev",4,"FOA/PMF afd. 1",163,1]
[657,"Herning",0,"FOA Herning",657,4]
[219,"Hillerød",3,"FOA Nordsjælland",219,1]
[860,"Hjørring",0,"FOA/PMF Vendsyssel",860,5]
[316,"Holbæk",0,"FOA Holbæk",316,2]
[661,"Holstebro",0,"FOA Holstebro",661,4]
[615,"Horsens",0,"FOA Horsens",615,4]
[167,"Hvidovre",4,"FOA/PMF Københavns amt Syd",167,1]
[169,"Høje-Taastrup",4,"FOA/PMF afd. 4",169,1]
[223,"Hørsholm",3,"FOA Nordsjælland",223,1]
[756,"Ikast-Brande",0,"FOA Herning",756,4]
[183,"Ishøj",4,"FOA/PMF afd. 4",183,1]
[849,"Jammerbugt",0,"FOA/PMF Vendsyssel",849,5]
[326,"Kalundborg",1,"FOA Nordvestsjælland",326,2]
[440,"Kerteminde",1,"FOA/PMF Fyns amt",440,3]
[621,"Kolding",0,"FOA Kolding",621,3]
[101,"København",4,"LFS",101,1]
[259,"Køge",2,"FOA Køge",259,2]
[482,"Langeland",0,"FOA/PMF Fyns amt",482,3]
[350,"Lejre",2,"FOA Roskilde",350,2]
[665,"Lemvig",0,"FOA Holstebro",665,4]
[360,"Lolland",0,"FOA Lolland",360,2]
[173,"Lyngby-Taarbæk",4,"FOA/PMF afd. 1",173,1]
[825,"Læsø",0,"FOA/PMF Vendsyssel",825,5]
[846,"Mariagerfjord",0,"FOA Hobro",846,5]
[410,"Middelfart",0,"FOA/PMF Fyns amt",410,3]
[773,"Morsø",0,"FOA Thisted-Morsø",773,5]
[707,"Norddjurs",0,"FOA Randers",707,4]
[480,"Nordfyn",0,"FOA/PMF Fyns amt",480,3]
[450,"Nyborg",1,"FOA/PMF Fyns amt",450,3]
[370,"Næstved",1,"FOA Sydsjælland",370,2]
[727,"Odder",0,"FOA Århus",727,4]
[461,"Odense",1,"FOA/PMF Fyns amt",461,3]
[306,"Odsherred",0,"FOA Nordvestsjælland",306,2]
[730,"Randers",0,"FOA Randers",730,4]
[840,"Rebild",0,"FOA Aalborg",840,5]
[760,"Ringkøbing-Skjern",0,"FOA Herning",760,4]
[329,"Ringsted",0,"FOA Midtsjælland",329,2]
[265,"Roskilde",2,"FOA Roskilde",265,2]
[230,"Rudersdal",4,"FOA Nordsjælland",230,1]
[175,"Rødovre",4,"FOA/PMF Københavns amt Syd",175,1]
[741,"Samsø",0,"FOA Århus",741,4]
[740,"Silkeborg",0,"FOA Silkeborg-Skanderborg",740,4]
[746,"Skanderborg",1,"FOA Silkeborg-Skanderborg",746,4]
[779,"Skive",0,"FOA Skive",779,4]
[330,"Slagelse",1,"FOA Midtsjælland",330,2]
[269,"Solrød",2,"FOA Køge",269,2]
[340,"Sorø",0,"FOA Midtsjælland",340,2]
[336,"Stevns",0,"FOA Køge",336,2]
[671,"Struer",0,"FOA Holstebro",671,4]
[479,"Svendborg",0,"FOA/PMF Fyns amt",479,3]
[706,"Syddjurs",0,"FOA Randers",706,4]
[540,"Sønderborg",1,"FOA Sønderborg",540,3]
[787,"Thisted",0,"FOA Thisted-Morsø",787,5]
[550,"Tønder",0,"FOA Sønderjylland",550,3]
[185,"Tårnby",4,"FOA/PMF Københavns amt Syd",185,1]
[187,"Vallensbæk",4,"FOA/PMF afd. 4",187,1]
[573,"Varde",0,"FOA Varde",573,3]
[575,"Vejen",0,"FOA Esbjerg",575,3]
[630,"Vejle",0,"FOA Vejle",630,3]
[820,"Vesthimmerland",0,"FOA Aalborg",820,5]
[791,"Viborg",0,"FOA Viborg",791,4]
[390,"Vordingborg",0,"FOA Sydsjælland",390,2]
[492,"Ærø",0,"FOA/PMF Fyns amt",492,3]
[580,"Aabenraa",0,"FOA Sønderjylland",580,3]
[851,"Ålborg",1,"FOA Aalborg",851,5]
[751,"Århus",2,"FOA Århus",751,4]

{"sheet":"Ark3","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}

{"sheet":"Ark1","index":5,"n_rows":11,"n_cols":9,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,"normtimer","arbejdstimer","opsparing"]
["marts",138,165.25,{"$f":"C3-B3","v":27.25},null,null,null,21785.14,21449.11]
["april",124.2,150.5,{"$f":"C4-B4","v":26.299999999999997},null,null,null,170.91]
["maj",138,143.5,5.5,null,null,null,1185.9000000000001]
["juni",144.9,177,32.099999999999994,null,null,null,104.65]
["juli",null,null,0,null,null,null,11.62]
[null,{"$f":"SUM(B3:B7)","v":545.1},{"$f":"SUM(C3:C7)","v":636.25},null,null,null,null,1068.8599999999999]
[null,null,null,null,null,null,null,546.45000000000005]
[null,null,null,null,null,null,null,-90]
[null,null,null,null,null,null,null,{"$f":"SUM(H3:H10)","v":24783.530000000002}]